
package factorymaterial;

/**
 *
 * @author Miguel Pichipillan S
 */
public class Query {

    
    public static String getQueryBuscarMaterialPorNombre (String nombre) {
        String query;
            query = " SELECT "
                    + "     ma_id_material AS id, "
                    + "     ma_material     AS material, "
                    + "     ma_descripcion  AS  descripcion "
                    + " FROM "
                    + "     bo_material "
                    + "WHERE "
                    + "     ma_material "
                    + " LIKE '%" + nombre + "%' ";
        return query;
    }
    
}
